<?php
class Order{
	
	const TABLE = 'orders';
	/**
	 * 
	 * 根据sn获取订单号
	 * @param $order_sn
	 */
	function getOrderByOrderSN($order_sn){
		global $db;

		$sql = "SELECT * FROM ".self::TABLE." WHERE order_sn = '$order_sn'";
		
		return $db->get_one($sql);
	}
}